Info

Level: Beginner
Presenter: Eli the Computer Guy
Length of Class: 30 Minutes
Tracks

Web Design
Prerequisites

Introduction to Website Administration
Purpose of Class

This class teaches new website administrators to be able to understand MySQL Databases for general administration.  This class does  not delve deep into database architecture and theory, it just teaches what is needed successfully manage a site that uses MySQL to store and retrieve data.
Topics Covered

What is a MySQL Database
How to Navigate through a MySQL Database using PHPMyAdmin
How to export, backup a database
How to extract data from a MySQL Database
Class Notes

Introduction
Databases are used to store data.
MySQL databases are most commonly used for websites because MySQL is open source and free.
Storing Data
MySQL Server software manages databases
A Database is generally the largest unit for storing data
Tables contain information about specific types of data (vendors, employees, parts list)
Columns in Tables store specific information (Frist Name, Last Name, ID Number)
Rows store Records in a Table (All of an Employees Record, or All Information about a Part
Employee Number Last Name First Name Email Address Phone Number
1 Evans Tom ton@gmail.com 444-444-4444
2 Thompson Fred fred@aol.com 555-555-5555-
Connecting to the Database
Database software allows for Users and Permissions like an Operating System does.
If the Database Server is on the SAME server as the Web Server then you connect to the database using LOCALHOST, if not you use the address of the Database Server
Working with MySQL
You can backup the entire database and restore it by exporting to the SQL format.
You can export TABLES into Excel spreadsheets to easily extract data such as site members email addresses.